UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPHbu/FwQ/cSWsighBL7aY9Z0D26o3yAP35ty7B8xTk='
WHERE
key_id = '0a3199562429122b3dc26b5554bc3384008f64a53058eda92f7f8962f972fe97'
AND (
token = 'NPHbu/FwQ/cSWsighBL7aY9Z0D26o3yAP35ty7B8xTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)