UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Y6i2dnl+FmrrmSRPnYGTDnUoa5jef0gYv8t2R/44Ao='
WHERE
key_id = '47a7ec9352999fbe5d47e094edcc9b3391809fffd1ca5bb62a31ff44f2ca8114'
AND (
token = '2Y6i2dnl+FmrrmSRPnYGTDnUoa5jef0gYv8t2R/44Ao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)