UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+b30XjfM9wkiO5SM9sFYWF8IffI256OpKdLI6fVllSw='
WHERE
key_id = '7d27465370ddda754cd4e792ebc0c0072c82247e1d233f4563a321927a49914d'
AND (
token = '+b30XjfM9wkiO5SM9sFYWF8IffI256OpKdLI6fVllSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)