UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ggmPj5FmRx0njNDjWVCZJQO8Y92EEw38jKZEXzYQVQ8='
WHERE
key_id = '0e0c64bd6705c9170174f50634670e56f727674b15ba620fd57fe6dc3a411830'
AND (
token = 'ggmPj5FmRx0njNDjWVCZJQO8Y92EEw38jKZEXzYQVQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)