UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9U6uv5WDJbFt78bFZCqnGrIpUT9l+XicgE8fO+kR3E='
WHERE
key_id = '8b790ca536a7d2e156f07d65ca2edd4e223da5f53e1fc941f7b57ed107a417dc'
AND (
token = 'A9U6uv5WDJbFt78bFZCqnGrIpUT9l+XicgE8fO+kR3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)