UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snt84Av/suo+wYCgjvTppBAfFrufWIhU5U9YFhrL+Ko='
WHERE
key_id = 'c6100f9b30fd1dbf64e6e9efce48e5a9a0e2cf744f19c6314cbea27f53de2be9'
AND (
token = 'snt84Av/suo+wYCgjvTppBAfFrufWIhU5U9YFhrL+Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)