UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f2DZlhLEFipXK3UTSBS2XiBaqhxZTxQ784VeslJO6+s='
WHERE
key_id = 'c5346c234356f68f0c8e305536ba2182127bf7711f81f3693c7168de269a4c46'
AND (
token = 'f2DZlhLEFipXK3UTSBS2XiBaqhxZTxQ784VeslJO6+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)