UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AdJNf5p6pY+xyumITh2ZyGPK/IQ7/SloIz0wwAVrsrg='
WHERE
key_id = 'ef8a24d0d44295ee3d3f8181fd27f608cf94dcf03f7d74e868aeb246d7e805b2'
AND (
token = 'AdJNf5p6pY+xyumITh2ZyGPK/IQ7/SloIz0wwAVrsrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)