UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AgvTYpGnlBL0+ZpjjxIuVp10+i10Y9lr/nL1JIeVoUw='
WHERE
key_id = 'b526e523cb561f2608fe29a9aa76895ed36299fd6769b2f0ea5a8aaf992c4874'
AND (
token = 'AgvTYpGnlBL0+ZpjjxIuVp10+i10Y9lr/nL1JIeVoUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)