UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I5WuemTzUJ80jCWmmFbHw32rTno8GNUUcpapBaG6+0M='
WHERE
key_id = 'def7521a0c126cd5aa73fb1a9c3ae39200b411c6ea0f42e919c914e203f7d3c9'
AND (
token = 'I5WuemTzUJ80jCWmmFbHw32rTno8GNUUcpapBaG6+0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)