UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lDMQOchhGf14agJTANdRxnow104ddSlj5pJsosg+sVs='
WHERE
key_id = 'f765d61ac4cbef3a3e0ac64bd3b58a35162d4619fccb7377e34776f2c15a4e50'
AND (
token = 'lDMQOchhGf14agJTANdRxnow104ddSlj5pJsosg+sVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)