UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Gm9nHE0PtVg7BZ6flrVtGUWxlU3RNSNv5SQfS9UQqo='
WHERE
key_id = '1172e8fd3f1824a90b6b2a3732fc826d5454d50556022c29b220c5340757d899'
AND (
token = '/Gm9nHE0PtVg7BZ6flrVtGUWxlU3RNSNv5SQfS9UQqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)