UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6tWoa12CqOKbITDgwchWVtKkABZknG55G8+U8lO7QM='
WHERE
key_id = '61b4d994884bfcdf5f9a35b84fa797354e4bf90c0a224e3734b43f2f0743e5fb'
AND (
token = 'G6tWoa12CqOKbITDgwchWVtKkABZknG55G8+U8lO7QM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)