UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bm7XnAdJ+ytNHEs28r+pAAyr601E3Ij2YrfVSwGfUHk='
WHERE
key_id = '6ebc04031acb2b31e24e9b014c3165324a01fd03400ae7c27daa687ec390c031'
AND (
token = 'Bm7XnAdJ+ytNHEs28r+pAAyr601E3Ij2YrfVSwGfUHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)