UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NqzGgMTKeQzBNweR/YiDz6497gUE8E9zjf/CFc1QgoA='
WHERE
key_id = '78931219af65845c437cf6fa0b0f2b1d16b523b4c63c9cc9e5e4b40f36fce7ea'
AND (
token = 'NqzGgMTKeQzBNweR/YiDz6497gUE8E9zjf/CFc1QgoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)