UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZTx/96Xt6NQsv2eaukXcDSI3I1BHqdbqAw6jM7oUFAk='
WHERE
key_id = 'e90f17e96014a888c1634aea6708ffda8ac4511bdc1e474c917eee4a9f54c5de'
AND (
token = 'ZTx/96Xt6NQsv2eaukXcDSI3I1BHqdbqAw6jM7oUFAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)