UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBYihUDYal3vCd7yUm2EzWj2eRDwGOJjJEa1fHaBCPI='
WHERE
key_id = 'e67a506242517801ca54704eae7f81c99f51ced6940d9e6324ff0dcba8cb7f5d'
AND (
token = 'TBYihUDYal3vCd7yUm2EzWj2eRDwGOJjJEa1fHaBCPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)