UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hBr/GGHVb8ob7eX+qVbXkSVOhvMz9g5WIBs3B+Amnrk='
WHERE
key_id = 'a97f3947028234ab2a1a7190a441fb871d4b113d380cd36bb26dfe3a71800b06'
AND (
token = 'hBr/GGHVb8ob7eX+qVbXkSVOhvMz9g5WIBs3B+Amnrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)