UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPey/RLx2Ic/CtaAsrwGg2aLM6atdOMopVt4gYXKG9w='
WHERE
key_id = '2f4269a8b3d7410f2f618bf39001114e44227064b51434114387728b0fc35296'
AND (
token = 'BPey/RLx2Ic/CtaAsrwGg2aLM6atdOMopVt4gYXKG9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)