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