UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kdXBulD9PtOJC5JgAjAiobBy/8EmXxEtOk+6U60Civ4='
WHERE
key_id = '244d74b5471d2214bd13fd8f996fa752d5574d8257839186bc8d42179c27867a'
AND (
token = 'kdXBulD9PtOJC5JgAjAiobBy/8EmXxEtOk+6U60Civ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)