UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F2pDLwYEnG9Lo4aRTuLyEpvHpPLwXTmY4V2Wg7kfuXQ='
WHERE
key_id = '4b9b790a6a54e5c9fe0e6d235c18da3860a0bbc3bf4bc2f9ac4b06871e14f173'
AND (
token = 'F2pDLwYEnG9Lo4aRTuLyEpvHpPLwXTmY4V2Wg7kfuXQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)