UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xn1rjqQzMtdA4rl9OmoZt8McMBrrSgPxKzwcZBV8JRA='
WHERE
key_id = '4cd9d3dfacfc24c9c5eff0d8ff4d167d393392851dcff40d96b1047ec680eaad'
AND (
token = 'xn1rjqQzMtdA4rl9OmoZt8McMBrrSgPxKzwcZBV8JRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)