UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGD+XzCIs35HUVrieLXudCyUMP/tHcgF7s4Do4m8lS0='
WHERE
key_id = '6ebae9c3951616ba10a1a92e3b256426bfdf1d7339891b84ce99b58854df9dca'
AND (
token = 'mGD+XzCIs35HUVrieLXudCyUMP/tHcgF7s4Do4m8lS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)