UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uHsHnE4wlVs0JlUot0tTVoDFLqUvbDXXXnMIL41A5WE='
WHERE
key_id = '6b3b4e13c65c5ffee820fe5a585efcba2567e4301880d8fb963e191cd8dc62fc'
AND (
token = 'uHsHnE4wlVs0JlUot0tTVoDFLqUvbDXXXnMIL41A5WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)