UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZ3Xlxu3Oe17T/lOrB+u0uDoLpj68X0ewcK+a/oKwgA='
WHERE
key_id = 'bc8bdae528cf8842f1f065c494cc506b2f3788441f00f2818336b5caf82e9307'
AND (
token = 'tZ3Xlxu3Oe17T/lOrB+u0uDoLpj68X0ewcK+a/oKwgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)