UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JFjsGwT/aUpX79QelZoJ3odZuF2pnznJIWL2/fAPq+w='
WHERE
key_id = '2a6ba9976abe8fec75c926019a47f8b6bcfff6754cb27cd2d42e5d653389deed'
AND (
token = 'JFjsGwT/aUpX79QelZoJ3odZuF2pnznJIWL2/fAPq+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)