UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihC4zg91/9eKkgOjQPFu4lFHerne51bANZpHoQXz2+o='
WHERE
key_id = '50bf8430f140eba11968959d93e67b4c77587f3593035a9d5f12116ed4a12954'
AND (
token = 'ihC4zg91/9eKkgOjQPFu4lFHerne51bANZpHoQXz2+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)