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