UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0DVqwXrs9BgSsnjuZtnutM6irMLMy93hYnTFSUYu8I='
WHERE
key_id = 'a0503df5f15fb547846a78720947b2f40e88f6473a6605d2cc00572964da4217'
AND (
token = 'U0DVqwXrs9BgSsnjuZtnutM6irMLMy93hYnTFSUYu8I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)