UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B46LPSI4Imab56zVmy5GLF4LCL/3RibtH6KfZHfU57s='
WHERE
key_id = '720797d7dca3d8cacabf5cb3e65dff9a3df9d5025b7eafd3ad724e3180ec97ea'
AND (
token = 'B46LPSI4Imab56zVmy5GLF4LCL/3RibtH6KfZHfU57s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)