UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJesEM0dt3RAkxvbDzj9Gx8IFurLaX6/Donkt5SIYSI='
WHERE
key_id = 'd9d4647e039253711ffabe516473c04e73f42e33c7809cadbdbfcdd353d2d301'
AND (
token = 'zJesEM0dt3RAkxvbDzj9Gx8IFurLaX6/Donkt5SIYSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)