UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXrn9hO9oE0SMs8oNNwdoSFE/mC41sYq+vd2kIqwJeA='
WHERE
key_id = '0e9b2a7e788428fa790404f9f011e8a3fb20a48bb5acc0fc7098eed96e630216'
AND (
token = 'WXrn9hO9oE0SMs8oNNwdoSFE/mC41sYq+vd2kIqwJeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)