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