UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xL9xcFeX+y/vXQLbLElwWCg/cxTFoSOBFGelHn1GS08='
WHERE
key_id = '28829e05b888f0eaaeadbf0585f9decc6fc51e968f5b375d7a7c840a3ab8c9ed'
AND (
token = 'xL9xcFeX+y/vXQLbLElwWCg/cxTFoSOBFGelHn1GS08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)