UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PA78g+4TwwhucmW+QhEE1hY0aCK/rYaG+eAp6dRM6Jg='
WHERE
key_id = '55a117d0877e8f55daa8a06d00741129ecc599a967419b1bcf57a3a5d0508e42'
AND (
token = 'PA78g+4TwwhucmW+QhEE1hY0aCK/rYaG+eAp6dRM6Jg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)