UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZkamlghRFQedMjtxzwLMzkGGHRDXXAH5V0rO09Un6M='
WHERE
key_id = 'b6c3694b82f9a116db13299f7c8361c8749de9faf51ba7430d8af0985ac62aa9'
AND (
token = 'PZkamlghRFQedMjtxzwLMzkGGHRDXXAH5V0rO09Un6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)