UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vXSJ3hKKcDj8p7+B7j1ojt3D8fitg1i+j+cQQ+04oDY='
WHERE
key_id = 'd780aaf4e620badaf664b5c829106ca9b6e294f534e97617feddafb9cf85a4eb'
AND (
token = 'vXSJ3hKKcDj8p7+B7j1ojt3D8fitg1i+j+cQQ+04oDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)