UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GJfzj5Kciit2+d/mMB/oNc1GStb1YhpWloX/Tv52A4Y='
WHERE
key_id = 'a7f06297a3ad0f6a87d2e5ca0626b8757f334894b93aa8098bab28abf8b72461'
AND (
token = 'GJfzj5Kciit2+d/mMB/oNc1GStb1YhpWloX/Tv52A4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)