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