UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3k7zRWEdh5I0SzK9/ljjxhj/MZjoecF9zE+zjqKLB6w='
WHERE
key_id = 'b138cb5f7170117c6868cec4d426a5d345a149d5334562654979b219b54967bd'
AND (
token = '3k7zRWEdh5I0SzK9/ljjxhj/MZjoecF9zE+zjqKLB6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)