UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Sp6pKwTeY97gfCt0BAJirpiIun2PumW34rg6pW+OCM='
WHERE
key_id = 'b182ae4da2e7dee374c4cee72faeec442854e098b0e518cb602e299137f55025'
AND (
token = '0Sp6pKwTeY97gfCt0BAJirpiIun2PumW34rg6pW+OCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)