UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7i7mQzq6P4t77TgCrnRULDXcIyAq53csZ3Rq5RLpnI='
WHERE
key_id = '6be881fad795a0aef9d00d3fb638177301c142322664a5ea2b62790cb989d8df'
AND (
token = 'b7i7mQzq6P4t77TgCrnRULDXcIyAq53csZ3Rq5RLpnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)