UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OOJ5SUIAowOaYNyKRbpxxKmHK6UbLUGB4osrS9qwFI='
WHERE
key_id = '0ca152f3cf275596520bd30187fc985f1f4a25e07138d51efd388ae66f14e1de'
AND (
token = '1OOJ5SUIAowOaYNyKRbpxxKmHK6UbLUGB4osrS9qwFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)