UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfG0j/sIgyzR7iAP2Jy9Z9a+8R3zVcpNQZgZvGiemzo='
WHERE
key_id = '20b07c6021fb569ae85de9be31b3f690ccf7929b396d35dc0b4c61c6aafb4412'
AND (
token = 'hfG0j/sIgyzR7iAP2Jy9Z9a+8R3zVcpNQZgZvGiemzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)