UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jCzj+IpjhPV4dPSrZktGZZvSj6RTaWTbDx66Bvx0Mbk='
WHERE
key_id = 'b8e73d7677356b8456076664d1a428a49ff745447250be46b2c72b8645077461'
AND (
token = 'jCzj+IpjhPV4dPSrZktGZZvSj6RTaWTbDx66Bvx0Mbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)